/*
 * Copyright (c) 2008 Anshuman Manur <anshuman.manur@gmail.com>,
 * Lavanya Shastri <lavanya.shastri@gmail.com>
 * 
 * This file is part of Andronova.
 * 
 * Andronova is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 2 of the License, or
 * (at your option) any later version.
 * 
 * Andronova is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *  
 * You should have received a copy of the GNU General Public License
 * along with Andronova.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */

package com.googlecode.andronova.helper;

public class DBConstants {	
	public static final String DB_NAME = "music";
	
	public static final int DB_VERSION = 1;
	
	public static final String LIB_TABLE_NAME = "metadata";
	public static final String PL_TABLE_NAME = "playlist";	
	
	public static final String CNAME_ID = "_id";	
	public static final String CNAME_LIB_ID = "lib_id";
	public static final String CNAME_PATH = "path";
	public static final String CNAME_TITLE = "title";
	public static final String CNAME_ARTIST = "artist";
	public static final String CNAME_ALBUM = "album";
	public static final String CNAME_YEAR = "yr";
	public static final String CNAME_GENRE = "genre";
	
	public static final String LIB_TABLE_CREATE = "create table " + LIB_TABLE_NAME + "("
		+ CNAME_ID + " integer primary key, "
		+ CNAME_PATH + " text not null, "
		+ CNAME_TITLE + " text not null, "
		+ CNAME_ALBUM + " text, "
		+ CNAME_ARTIST + " text, "
		+ CNAME_GENRE + " text, "
		+ CNAME_YEAR + " text)";
	
	public static final String PLED_TABLE_CREATE = "create table " + PL_TABLE_NAME + "("
		+ CNAME_ID + " integer primary key, "
		+ CNAME_LIB_ID + " integer not null, "
		+ CNAME_PATH + " text not null, "
		+ CNAME_TITLE + " text not null, "
		+ CNAME_ALBUM + " text, "
		+ CNAME_ARTIST + " text)";
	
	private DBConstants() {}
}
